﻿CREATE TABLE [acms].[Posts]
(
	Id	int NOT NULL identity(1,1), 
	SiteId int NOT NULL,
	PostGuid uniqueidentifier NOT NULL,
	ParentGuid uniqueidentifier,
	Name varchar(100),
	DisplayName varchar(100),
	Sequence int NOT NULL,
	TemplateId int,
	ThumbnailId int,
	Summary varchar(2000),
	Keywords varchar(2000),
	CreatedDateTime DateTime NOT NULL,
	PublishFrom DateTime,
	PublishTo DateTime,
	Notes nvarchar(2000),
	RequiresPublishing bit NOT NULL,
	ReadyToPublish bit NOT NULL,
	DeveloperLocked bit NOT NULL,
	Deleted bit NOT NULL,
	VersionId Timestamp 
);
